from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()


class zhaoshengStudentData(db.Model):
    __tablename__ = 'studentData'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    # 性别
    sex = db.Column(db.String(20))
    # 考生类别
    studentType = db.Column(db.String(50))
    # 录取年级
    year = db.Column(db.String(50))
    # 院系名称
    college = db.Column(db.String(100))
    # 专业名称
    professional=db.Column(db.String(50))
    # 是否报道
    reported=db.Column(db.String(50))
    # 招生类别
    recruitType = db.Column(db.String(50))
    # 全国各省
    chinaProvince = db.Column(db.String(50))
    # 广东各市
    guangdongProvince = db.Column(db.String(50))


#图书借阅数据
class bookStudentData(db.Model):
    __tablename__='bookData'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    #名字
    stu_name=db.Column(db.String(50))
    #专业
    professional = db.Column(db.String(50))
    #财产号
    money_number=db.Column(db.String(50))
    #书名
    book_name=db.Column(db.String(400))
    #索书号
    book_index=db.Column(db.String(50))
    #藏馆地
    book_hold=db.Column(db.String(50))




# 性格数据
class characterData(db.Model):
    __tablename__ = 'characterData'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    affair = db.Column(db.Float)
    operation = db.Column(db.Float)
    skill = db.Column(db.Float)
    plan = db.Column(db.Float)
    invention = db.Column(db.Float)
    art = db.Column(db.Float)
    humanity = db.Column(db.Float)
    service = db.Column(db.Float)
    communication = db.Column(db.Float)
    influence = db.Column(db.Float)
    extension = db.Column(db.Float)
    control = db.Column(db.Float)


# 成绩数据
class achievementData(db.Model):
    __tablename__ = 'achievementData'
    # 第一学期
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    web_design = db.Column(db.Float)
    applied_mathematics_1 = db.Column(db.Float)
    fundamentals_of_programming = db.Column(db.Float)
    data_base = db.Column(db.Float)
    # 第二学期
    applied_mathematics_2 = db.Column(db.Float)
    linux_system = db.Column(db.Float)
    python_program = db.Column(db.Float)
    hadoop_data = db.Column(db.Float)
